System and method for generating a company group user profile

ABSTRACT

An enterprise provides procurement services to a plurality of companies organized in company groups, each company group including those companies using the same accounting rules. These services are accessed by customer company employees, or users. The creation and maintenance of user profile for each user authorized by a customer company is accomplished according company groupings. Company name is passed to the enterprise in a human resource file or interface, to which a company grouping code is added. That data is loaded into employee staging tables from which an application builds a user profile table which, for new users, does not include company code and location code. These codes will be populated to the profile the first time the user logs in for service and selects from a drop down list describing all work locations for his company group a line item including a description of his work location.

Cross References to Related Applications

[0001] The following U.S. Pat. applications, filed concurrently or otherwise copending, are assigned to the assignee hereof and contain subject matter related, in certain respect, to the subject matter of the present application.

[0002] Ser. No. 09/657,215, filed Sep. 7, 2000 entitled “System and Method for Clustering Servers for Performance and Load Balancing”, assignee docket END9-2000-0104-US1;

[0003] Ser. No. 09/657,216, filed Sep. 7, 2000, entitled “System and Method for Front End Business Logic and Validation”, assignee docket END9-2000-0105-US1;

[0004] Ser. No. 09/657,217, filed Sep. 7, 2000, entitled “System and Method for Data Transfer With Respect to External Applications”, assignee docket END9-2000-0106-US1;

[0005] Ser. No. 09/656,037, filed Sep. 7, 2000 entitled “System and Method for Providing a Relational Database Backend”, assignee docket END9-2000-0107-US1;

[0006] Ser. No. 09/656,803, filed Sep. 7, 2000 entitled “System and Method for Providing a Role Table GUI via Company Group”, assignee docket END9-2000-0108-US1;

[0007] Ser. No. 09/656,967, filed Sep. 7, 2000 entitled “System and Method for Populating HTML Forms Using Relational Database Agents”, assignee docket END9-2000-0109-US1;

[0008] Ser. No. 09/657,196, filed Sep. 7, 2000 entitled “System and Method for Catalog Administration Using Supplier Provided Flat Files”, assignee docket END9-2000-0110-US1; and

[0009] Ser. No. 09/657,195, filed Sep. 7, 2000 entitled “System and Method for Providing an Application Navigator Client Menu Side Bar”, assignee docket END9-2000-0111-US1.

[0010] Ser. No. 09/______ , entitled “SYSTEM AND METHOD FOR AUTOMATING INVOICE PROCESSING WITH POSITIVE CONFIRMATION”, assignee docket number END9 2000 0165 US1.

[0011] Ser. No. 09/______ , entitled “SYSTEM AND METHOD FOR SHARING DATA ACROSS FRAMES USING ENVIRONMENT VARIABLES”, assignee docket number END9 2000 0167 US1.

[0012] Ser. No. 09/______ , entitled “SYSTEM AND METHOD FOR SYNCHRONIZING LEDGER ACCOUNTS BY COMPANY GROUP”, assignee docket number END9 2000 0168 US1.

[0013] Ser. No. 09/______ , entitled “SYSTEM AND METHOD FOR GROUPING COMPANIES ACCORDING TO ACCOUNTING SYSTEM OR RULES”, assignee docket number END9 2000 0169 US1.

[0014] Ser. No. 09/______ ,entitled “SYSTEM AND METHOD FOR FRAME STORAGE OF EXECUTABLE CODE”, assignee docket number END9 2000 0174 US1.

[0015] Ser. No. 09/______ ,entitled “SYSTEM AND METHOD FOR INVOICE IMAGING THROUGH NEGATIVE CONFIRMATION PROCESS”, assignee docket number END9 2000 0175 US1.

[0016] Ser. No. 09/______ , entitled “SYSTEM AND METHOD FOR LEVERAGING PROCUREMENT ACROSS COMPANIES AND COMPANY GROUPS”, assignee docket number END9 2000 0176 US1.

[0017] Ser. No. 09/______ , entitled “SYSTEM AND METHOD FOR PROCESSING TAX CODES BY COMPANY GROUP”, assignee docket number END9 2000 0177 US1.

[0018] Ser. No. 09/______ , filed Mar. 2, 2001 entitled “SYSTEM AND METHOD FOR MANAGING INTERNET TRADING NETWORKS”, assignee docket number END9 2000 0178 US1.

[0019] The above-identified patent applications are incorporated herein by reference.

BACKGROUND OF THE INVENTION

[0020] TECHNICAL FIELD OF THE INVENTION

[0021] This invention pertains to a procurement and accounting system. More particularly, it relates to a system for preparing user profiles for customer company employees authorized to access an enterprise procurement and requisition system.

[0022] BACKGROUND ART

[0023] A requisition and catalog (RCW) system for access via the web and deployed to customers of an enterprise requires visibility to all of the authorized users. The RCW system requires for each authorized user his name, employee number, address (default ship to address for procured goods and services), and E-mail address. Previously, this information was gathered from various sources, a complex and time consuming process.

[0024] The enterprise procurement services system, such as the SAP system, and RCW system further require for each such user a company code and a plant code. SAP is a procurement engine used by the an enterprise to satisfy the procurement requirements of a customer company. These codes are configuration entities in SAP, and unknown to the authorized users. There is required a system and method for collecting authorized user identification data and corresponding codes before the user can be permitted to log on to the RCW system to submit a purchase requisition.

[0025] A most difficult problem facing such an enterprise is helping customer companies provide such data about its employees. The system and method provided for doing so must be easy for a user requester to use, isolating him from technicalities of SAP or other such back end engines.

[0026] Further, such a system must make provision for updating the user profile if an employee transfers to a new company within a company group, or to a new plant location.

[0027] It is an object of the invention to provide an improved system and method for creating user profiles.

[0028] It is a further object of the invention to provide a system and method for creating user profiles which is easy to use by a prospective requisition requester.

[0029] It is a further object of the invention to provide a system and method for authorizing access to a requisition and catalog system by an employee of a company within a company group for which an enterprise provides procurement services.

[0030] It is a further object of the invention to provide an improved system and method for reconfiguring a user profile when that user changes company location.

SUMMARY OF THE INVENTION

[0031] A system and method for creating a user profile for a user authorized by a customer company to access services provided by an enterprise, the method including the steps of preparing for each new user a profile entry including a user identifier and company group identifier; responsive to access by an authorized user, obtaining a corresponding profile entry; responsive to the profile entry not including company code and location indicia, displaying to user descriptions of locations for the company group; and responsive to user selection of a location description, populating to the profile entry the corresponding company code and location code.

[0032] In accordance with an aspect of the invention, there is provided a computer program product configured to be operable to creating a user profile for a user authorized by a customer company to access services provided by an enterprise.

[0033] Other features and advantages of this invention will become apparent from the following detailed description of the presently preferred embodiment of the invention, taken in conjunction with the accompanying drawings.

BRIEF DESCRIPTION OF THE DRAWINGS

[0034]FIG. 1 is a diagram illustrating the user profile creation and maintenance system and method of the preferred embodiment of the invention.

BEST MODE FOR CARRYING OUT THE INVENTION

[0035] In accordance with the preferred embodiment of the invention, an enterprise provides procurement services to a plurality of customer companies organized in company groups, each company group including one or more related companies which use the same accounting codes and procedures.

[0036] Referring to FIG. 1, a plurality of related companies 59, 59A are connected to a hub server which includes a company group human resources file. Hub server is connected through fire wall 372 to a requisition and catalog (ReqCatWeb, or RCW) application server 376. RCW server 374 includes a company group HR file, a staging table build application 378 and a new employee profile build application 382. Applications 402, 404 are logically connected to database server 388, which includes staging table 380, user profile table 384, and plant code table 386.

[0037] Connected to an RCW web server 390 deployed to customer companies through extra net 394 is a browser operable by a user for accessing a catalog (not shown) maintained by the enterprise, and for submitting to the enterprise requisitions for purchase of commodities and services against the accounts of a customer company. In exemplary embodiment, extra net 394 may be a secure network, such as a frame relay network connection, or a secure protocol on the world wide web.

[0038] To support procurement services for a plurality of users from different companies, the enterprise RCW system requires visibility to all of the users, and requires for each user his name, employee number, address (default ship to address for procured goods and services), E-mail address, and a SAP company code and plant code, which are configuration entities in SAP.

[0039] In operation, by way of overview, the creation and maintenance of the user profile is accomplished according company groupings: these are titles of corporations, and each grouping may have many company codes (a company grouping is a legal entity with its own requirements). Company name is passed in a human resource file or interface, to which a company grouping code is added. That data is loaded into employee staging tables of RCW. The process then looks for new employees, builds an employee profile which includes company code and group code (orginally blank, then filled out using tables of grouping, company code, plant code, description). A pop down menu advises a new person to select a location, and from that the employee profile is built.

[0040] In step 60, on a periodic basis, customer companies provides an HR file containing a list of all employees that are authorized to use RCW with a company grouping ID in a company code field. Hub server 52 merges these HR files 59, 59A into a company group HR file 370 which, in step 70, it transmits through fire wall 372 to application server 376 where it is stored in company group HR file 374.

[0041] In step 401, staging table build application reads file 374 and in step 402 moves it to staging table 380 in database server 388. At this point, company group HR file 374 includes an entry for each person authorized by companies within a company group, and that entry includes the information available from the customer companies but not other information, such as company code and location code, required by servers 390, 376 and the SAP system and unavailable from the company HR files 59, 59A.

[0042] In step 403, new employee profile build application reads from staging table 380 the authorized users and in step 404 adds to user profile table 384 an entry for each new user. At this point, user profile table includes an entry for all authorized users for a company grouping, but critical information (company code and location code) is missing for newly authorized (or changed) users.

[0043] Responsive to a request received at web server 390 from requester browser 46 to enter a transaction on behalf of a user, such as accessing a catalog and submitting a requisition for a commodity or service, in step 407 requisition application 392 accesses user profile table 384 to obtain the user's profile. It determines if the user profile for the user has SAP company code and plant code entries, and if not, executes a new user procedure to complete the preparation of the user profile.

[0044] In step 409, for a new user, application 392 accesses plant code table 386. Plant code table 386 includes a table including a plurality of entries, each entry including company group code, company code, and location code fields and a description which is meaningful to prospective users. Each company group code may apply to a plurality of company codes, and each company code to a plurality of location codes. From plant code table 386, requisition application 392 populates in step 408 at browser 46 a pop-down list 396 which includes each combination of company code, location code and description for the user's company group. (The user's company group is input from browser 46 when the user logs on to web server 390.)

[0045] The user selects from the pop-down list 396 the location at which he works, which in step 406 is sent back to application 392. In step 410, application 392 populates the user profile entry in user profile table 384 for this user with the company code and location code corresponding to the description at pop-down list 396 selected by the user. This completes the user profile entry for this user, who no longer is a new user and may now proceed to access the financial services provided by the enterprise for the company group of which he is an authorized user.

[0046] If an employee transfers, that is nicely handled by making the person look like a new employee when, in steps 60 and 70 his profile data is submitted to application server 376, which will trigger the above process for updating the entry for the user in user profile table 384.

ADVANTAGES OVER THE PRIOR ART

[0047] It is an advantage of the invention that there is provided an improved system and method for creating user profiles.

[0048] It is a further advantage of the invention that there is provided a system and method for creating user profiles which is easy to use by a prospective requisition requester.

[0049] It is a further advantage of the invention that there is provided a system and method for authorizing access to a requisition and catalog system by an employee of a company within a company group for which an enterprise provides procurement services.

[0050] It is a further advantage of the invention that there is provided an improved system and method for reconfiguring a user profile when that user changes company location.

ALTERNATIVE EMBODIMENTS

[0051] It will be appreciated that, although specific embodiments of the invention have been described herein for purposes of illustration, various modifications may be made without departing from the spirit and scope of the invention. In particular, it is within the scope of the invention to provide a computer program product or program element, or a program storage or memory device such as a solid or fluid transmission medium, magnetic or optical wire, tape or disc, or the like, for storing signals readable by a machine, for controlling the operation of a computer according to the method of the invention and/or to structure its components in accordance with the system of the invention.

[0052] Further, each step of the method may be executed on any general computer, such as an IBM System 390, AS/400, PC or the like and pursuant to one or more, or a part of one or more, program elements, modules or objects generated from any programming language, such as C++, Java, P1/1, Fortran or the like. And still further, each said step, or a file or object or the like implementing each said step, may be executed by special purpose hardware or a circuit module designed for that purpose.

[0053] Accordingly, the scope of protection of this invention is limited only by the following claims and their equivalents. 

We claim:
 1. A method for creating a user profile for a user authorized by a customer company to access services provided by an enterprise, comprising the steps of: preparing for each new said user a profile entry including a user identifier and a company group identifier; responsive to access by said authorized user, obtaining a profile entry for said authorized user; responsive to said profile entry not including company code and location indicia, displaying to said user descriptions of locations for said company group; and responsive to user selection of a said location description, populating to said profile entry the corresponding company code and location code.
 2. A method for creating a user profile for a user authorized by a customer company to access services provided by an enterprise, comprising the steps of on a periodic basis, receiving from each said customer company within a company group a file containing a list of all employees authorized by a company to use said services; merging said files into a company group file of authorized users; with reference to said company group file, building a user profile entry for each new said authorized user, said user profile entry including company group indicia but not including accounting code indicia not provided by said customer company; responsive to a request from a requester to access said services, reading said user profile entry for said requester; responsive to said profile entry not including said accounting code indicia for said requester, displaying to said requester descriptions of code indicia for said company group; and responsive to user selection of a code indicia description, populating to said profile entry corresponding accounting code indicia.
 3. The method of claim 2, said accounting code indicia including company code and location code indicia.
 4. The method of claim 2, further comprising the steps of: merging said files into a merged file in a hub server within a customer system; transmitting said merged file to a staging table within an enterprise system server.
 5. The method of claim 4, further comprising the steps of: building a plant code table including for each company code and location code combination associated with a company group a requester intelligible location description; and displaying said requester intelligible location descriptions associated with said company group in a selection list to said requester when said accounting indicia is not included in said user profile for said requester.
 6. The method of claim 5, said transmitting step occurring through a firewall, and said displaying step occurring through a secure network.
 7. The method of claim 6, said secure network being a frame relay network.
 8. System for creating a user profile for a user authorized by a customer company to access services provided by an enterprise, comprising: a profile table including for each authorized user a profile entry including a user identifier and a company group identifier; application code responsive to a request by a new authorized user for access to said services for displaying a selection list of descriptions of accounting indicia necessary to process said request; said application code being further responsive to user selection of a description of accounting indicia for populating to said profile entry said accounting indicia.
 9. The system of claim 8, said application code identifying a new user as an authorized user from whcih said profile entry does not include said accounting indicia.
 10. The system of claim 8, said accounting indicia including company code and location code.
 11. The system of claim 10, further comprising a plant code table including for each combination of company code and location code associated with a company group a corresponding said description of accounting indicia.
 12. The system of claim 11, said description of said accounting indicia being text comprehensible to said user.
 13. A program storage device readable by a machine, tangibly embodying a program of instructions executable by a machine to perform method steps for creating a user profile for a user authorized by a customer company to access services provided by an enterprise, said method steps comprising: preparing for each new said user a profile entry including a user identifier and a company group identifier; responsive to access by said authorized user, obtaining a profile entry for said authorized user; responsive to said profile entry not including company code and location indicia, displaying to said user descriptions of locations for said company group; and responsive to user selection of a said location description, populating to said profile entry the corresponding company code and location code.
 14. A program storage device readable by a machine, tangibly embodying a program of instructions executable by a machine to perform method steps for creating a user profile for a user authorized by a customer company to access services provided by an enterprise, said method steps comprising: on a periodic basis, receiving from each said customer company within a company group a file containing a list of all employees authorized by a company to use said services; merging said files into a company group file of authorized users; with reference to said company group file, building a user profile entry for each new said authorized user, said user profile entry including company group indicia but not including accounting code indicia not provided by said customer company; responsive to a request from a requester to access said services, reading said user profile entry for said requester; responsive to said profile entry not including said accounting code indicia for said requester, displaying to said requester descriptions of code indicia for said company group; and responsive to user selection of a code indicia description, populating to said profile entry corresponding accounting code indicia.
 15. A computer program product or computer program element for creating a user profile for a user authorized by a customer company to access services provided by an enterprise according to method steps comprising: preparing for each new said user a profile entry including a user identifier and a company group identifier; responsive to access by said authorized user, obtaining a profile entry for said authorized user; responsive to said profile entry not including company code and location indicia, displaying to said user descriptions of locations for said company group; and responsive to user selection of a said location description, populating to said profile entry the corresponding company code and location code. 